﻿CREATE TABLE [dbo].[Statistics_Financial_CE] (
    [id]          INT             IDENTITY (1, 1) NOT NULL,
    [companyid]   INT             NULL,
    [companyname] NVARCHAR (200)  CONSTRAINT [DF_Statistics_Financial_CE_companyname] DEFAULT ('') NULL,
    [createdate]  DATETIME        NULL,
    [c1]          DECIMAL (18, 2) NULL,
    [c2]          DECIMAL (18, 2) NULL,
    [c3]          DECIMAL (18, 2) NULL,
    [c4]          DECIMAL (18, 2) NULL,
    [c5]          DECIMAL (18, 2) NULL,
    [c6]          DECIMAL (18, 2) NULL,
    [c7]          DECIMAL (18, 2) NULL,
    [c8]          DECIMAL (18, 2) NULL,
    [c9]          DECIMAL (18, 2) NULL,
    [c10]         DECIMAL (18, 2) NULL,
    [c11]         DECIMAL (18, 2) NULL,
    [c12]         DECIMAL (18, 2) NULL,
    [c13]         DECIMAL (18, 2) NULL,
    [c14]         DECIMAL (18, 2) NULL,
    [c15]         DECIMAL (18, 2) NULL,
    [c16]         DECIMAL (18, 2) NULL,
    [c17]         DECIMAL (18, 2) NULL,
    [c18]         DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_CE_c18] DEFAULT ((0)) NULL,
    [c19]         DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_CE_c19] DEFAULT ((0)) NULL,
    [c20]         DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_CE_c20] DEFAULT ((0)) NULL,
    [c21]         DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_CE_c21] DEFAULT ((0)) NULL,
    [c22]         DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_CE_c22] DEFAULT ((0)) NULL,
    [zje]         DECIMAL (18, 2) NULL,
    [zrdk]        DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_CE_zrdk] DEFAULT ((0)) NULL,
    [fqzc]        DECIMAL (18, 2) CONSTRAINT [DF_Statistics_Financial_CE_fqzc] DEFAULT ((0)) NULL,
    CONSTRAINT [PK_Statistics_Financial_CE] PRIMARY KEY CLUSTERED ([id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'上期资金', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c1';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'新增毛利', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c2';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'续费毛利	', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c3';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'成本支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c4';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'费用 (成本类,分红,借款支出,投资支出,调款支出 不算费用)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c5';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'尾款收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c6';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'新增应收', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c7';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'新增应付', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c8';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'借款支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c9';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'借款收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c10';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'投资支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c11';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'投资收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c12';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'分红', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c13';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'未认多款', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c14';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'调款支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c15';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'调款收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c16';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'当日资金', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c17';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'当日账户余额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c18';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'昨日账户余额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c19';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'非营业性收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c20';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'补划成本', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c21';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'实收纯利外收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'c22';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'差额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Statistics_Financial_CE', @level2type = N'COLUMN', @level2name = N'zje';

